package com.swj.reggie.service.impl;

import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import com.swj.reggie.common.CustomException;
import com.swj.reggie.dto.DishDto;
import com.swj.reggie.entity.Dish;
import com.swj.reggie.entity.DishFlavor;
import com.swj.reggie.entity.Setmeal;
import com.swj.reggie.entity.SetmealDish;
import com.swj.reggie.mapper.DishMapper;
import com.swj.reggie.service.DishFlavorService;
import com.swj.reggie.service.DishService;
import com.swj.reggie.service.SetmealDishService;
import lombok.extern.slf4j.Slf4j;
import org.springframework.beans.BeanUtils;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;

import java.util.List;
import java.util.stream.Collectors;

@Service
@Slf4j
public class DishServiceImpl extends ServiceImpl<DishMapper,Dish> implements DishService {
    @Autowired
    private DishFlavorService dishFlavorService;

    @Autowired
    private SetmealDishService setmealDishService;

    /**
     * 新增菜品，同时保存对应的口味数据，要加上事务控制，同成功同失败
     * @param dishDto
     */
    @Transactional
    public void saveWithFlavor(DishDto dishDto) {
        //保存菜品的基本信息到菜品表dish
        this.save(dishDto);

//        Long dishId = dishDto.getId();  // 获取菜品dishId，要插入到菜品口味表中，类似与外键
        List<DishFlavor> flavors = dishDto.getFlavors();    // !!!获取菜品口味，此时菜品口味数据只有name和value，没有dishId
        // Stream流 简化集合的操作  .stream()获取流 --> map()加工方法 --> collect()收集stream流转为集合
        flavors = flavors.stream().map((item) -> {
            item.setDishId(dishDto.getId());     // 菜品ID加入到菜品口味数据中,类似于外键
            return item;
        }).collect(Collectors.toList());

        //保存菜品口味数据到菜品口味表dish_flavor     saveBatch()批量保存
        dishFlavorService.saveBatch(flavors);

    }

    /**
     * 根据id查询菜品信息和对应的口味信息
     * @param id
     * @return
     */
    public DishDto getByIdWithFlavor(Long id) {
        //查询菜品基本信息，从dish表查询
        Dish dish = this.getById(id);

        //查询当前菜品对应的口味信息，从dish_flavor表查询
        LambdaQueryWrapper<DishFlavor> queryWrapper = new LambdaQueryWrapper<>();
        queryWrapper.eq(DishFlavor::getDishId,id);
        List<DishFlavor> flavors = dishFlavorService.list(queryWrapper);

        // 封装结果
        DishDto dishDto = new DishDto();
        BeanUtils.copyProperties(dish,dishDto);
        dishDto.setFlavors(flavors);

        return dishDto;
    }

    @Transactional
    public void updateWithFlavor(DishDto dishDto) {
        //1、更新dish表基本信息
        this.updateById(dishDto);   // dishDto = dish + dishFlavors

        //2.1、清理当前菜品对应口味数据---dish_flavor表的delete操作  delete from dish_flavor where dish_id=?
        LambdaQueryWrapper<DishFlavor> queryWrapper = new LambdaQueryWrapper<>();
        queryWrapper.eq(DishFlavor::getDishId,dishDto.getId());
        dishFlavorService.remove(queryWrapper);

        //2.2、添加当前提交过来的口味数据---dish_flavor表的insert操作
        List<DishFlavor> flavors = dishDto.getFlavors();    // !!!获取菜品口味，此时菜品口味数据只有name和value，没有dishId
        // Stream流 简化集合的操作  .stream()获取流 --> map()加工方法 --> collect()收集stream流转为集合
        flavors = flavors.stream().map((item) -> {
            item.setDishId(dishDto.getId());     // 菜品ID加入到菜品口味数据中,类似于外键
            return item;
        }).collect(Collectors.toList());

        //保存菜品口味数据到菜品口味表dish_flavor     saveBatch()批量保存
        dishFlavorService.saveBatch(flavors);

    }

    /**
     * 删除菜品，同时需要删除菜品和菜品口味的关联数据，如果菜品已经关联了套餐，不能删除！！！
     * @param ids
     */
    @Transactional
    public void removeWithFlavor(List<Long> ids) {
        //select count(*) from dish where id in (1,2,3) and status = 1
        // 1、查询菜品状态，确定是否可用删除
        LambdaQueryWrapper<Dish> queryWrapper = new LambdaQueryWrapper();
        queryWrapper.in(Dish::getId,ids).eq(Dish::getStatus,1);

        int count1 = this.count(queryWrapper);
        if(count1 > 0){
            //如果不能删除，抛出一个业务异常
            throw new CustomException("菜品正在售卖中，不能删除");
        }
        //如果可以删除，先删除菜品表中的数据---setmeal

        // 2、查询菜品是否关联了套餐，如果已经关联，不可删除，抛出一个业务异常
        LambdaQueryWrapper<SetmealDish> setmealLambdaQueryWrapper = new LambdaQueryWrapper<>();
        //添加查询条件，根据菜品id进行查询
        setmealLambdaQueryWrapper.in(SetmealDish::getDishId,ids);   // select count* from setmeal where dishId in ids
        int count2 = setmealDishService.count(setmealLambdaQueryWrapper);
        if(count2 > 0){
            //已经关联套餐，抛出一个业务异常
            throw new CustomException("菜品关联了套餐，不能删除");
        }

        // 3、正常删除菜品
        this.removeByIds(ids);

        //delete from dish_flavor where dish_id in (1,2,3)
        LambdaQueryWrapper<DishFlavor> lambdaQueryWrapper = new LambdaQueryWrapper<>();
        lambdaQueryWrapper.in(DishFlavor::getDishId,ids);   // where dish_id in ids
        //删除关系表中的数据----dish_flavor
        dishFlavorService.remove(lambdaQueryWrapper);
    }
}
